GeneralLedgerReleaseBatchDetail

EntityType | Independent
Logical Entity Name | GeneralLedgerReleaseBatchDetail
Default Table Name | SaGLRelease
Logical Only | NO
Owner | dbo
Definition |
Note |

GeneralLedgerReleaseBatchDetail Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
GeneralLedgerReleaseBatchDetailId |  | INTEGER | NO |
StudentAccountTransactionId |  | INTEGER | YES |
StudentRevenueDetailId |  | INTEGER | YES |
BatchNumber |  | CHAR(8) | NO |
TransactionDate |  | DATETIME | YES |
AccountNumber |  | NVARCHAR(100) | NO |
DebitAmount |  | MONEY(19, 4) | NO |
CreditAmount |  | MONEY(19, 4) | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
LastModifiedUserId |  | INTEGER | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
TransactionDescription |  | VARCHAR(50) | YES |
GreatPlainsAccountIndex |  | INTEGER | NO |
StudentId |  | INTEGER | YES |
Type |  | CHAR(3) | YES |
MiscellaneousCashId |  | INTEGER | YES |
StudentSubsidiaryAccountTransactionId |  | INTEGER | YES |
GL_Entry |  | VARCHAR(25) | YES |
Period |  | SMALLINT | YES |
FiscalYear |  | VARCHAR(5) | YES |
IsReleasedToVantage |  | BIT | NO |
JournalEntryId |  | INTEGER | YES |
BankDepositId |  | INTEGER | YES |
CostAccount |  | CHAR(30) | YES |
PayeeName |  | NVARCHAR(150) | YES |
PayeeAddress |  | NVARCHAR(300) | YES |
BankDepositId |  | INTEGER | YES |
JournalEntryId |  | INTEGER | YES |

GeneralLedgerReleaseBatchDetail Keys

Key Name | Key Type | Keys
SaGLRelease_BatchNo_N_N_IDX | Inversion Entry | BatchNumber
SaGlRelease_SaStudSubsidiaryTransID_SaGlReleaseID_U_N_IDX | Alternate Key | StudentSubsidiaryAccountTransactionId, GeneralLedgerReleaseBatchDetailId
SaGLRelease_SaGLReleaseID_U_C_IDX | PrimaryKey | GeneralLedgerReleaseBatchDetailId

GeneralLedgerReleaseBatchDetail Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
BankDeposit | Non-Identifying | Zero or One to Zero or More |  |  |  | BankDepositId | NO
BankDeposit | Non-Identifying | Zero or One to Zero or More |  |  |  | BankDepositId | NO
JournalEntry | Non-Identifying | Zero or One to Zero or More |  |  |  | JournalEntryId | NO
StudentSubsidiaryAccountTransaction | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentSubsidiaryAccountTransactionId | NO
JournalEntry | Non-Identifying | Zero or One to Zero or More |  |  |  | JournalEntryId | NO
MiscellaneousCash | Non-Identifying | Zero or One to Zero or More |  |  |  | MiscellaneousCashId | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentId | NO
StudentAccountTransaction | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentAccountTransactionId | NO
StudentRevenueDetail | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentRevenueDetailId | NO
StudentSubsidiaryAccountTransaction | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentSubsidiaryAccountTransactionId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

GeneralLedgerReleaseBatchDetail Check Constraints

Check Constraint Name | CheckConstraint

GeneralLedgerReleaseBatchDetail Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.GeneralLedgerReleaseBatchDetail | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaGLRelease | NO |  |  |

GeneralLedgerReleaseBatchDetail Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Revenue_GL_BankDeposit
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

GeneralLedgerReleaseBatchDetail Data Movement Rules

Name | Type | Rule Text/Value